from sqlalchemy import Column, ForeignKey, Date
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER
from app.db.base import Base


# Scholar Status Lookup
class ScholarStatus(Base):
    __tablename__ = 'SCHOLAR_STATUS'
    __table_args__ = {'schema': 'IARO_CAREER'}

    status_id = Column(NUMBER, primary_key=True)
    status_description = Column(VARCHAR2(50), nullable=False)

    # One scholar status -> many scholars
    scholars = relationship("Scholar", back_populates="status")